<!--#include file="lib/utf-8.asp"-->
<!--#include file="lib/conn.asp"-->
<!--#include file="lib/saferequest.asp"-->
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
<link rel="stylesheet" href="lib/sheet.css" type="text/css">
<link rel="stylesheet" href="lib/jquery_datatables_lastest/media/css/demo_page.css" type="text/css">
<link rel="stylesheet" href="lib/jquery_datatables_lastest/media/css/demo_table_jui.css" type="text/css">
<link rel="stylesheet" href="lib/jquery_ui_lastest/themes/base/jquery_ui_lastest.css" type="text/css">
<script type="text/javascript" src="lib/jquery_lastest.js"></script>
<script type="text/javascript" src="lib/jquery_datatables_lastest/media/js/jquery.dataTables.min.js"></script>
<script type="text/javascript">
	$(function() {
				//$(".contable").addClass("ct");	//载入table样式
				//$(".contable th").addClass("ch");	//载入th样式
				//$(".contable td").addClass("cd");	//载入td样式

				//$("#contable tbody tr:odd").addClass("odd");	//对表格主体内单数行进行样式应用

				//$(".contable tbody tr").hover(function(){	//对返回的dom进行hover事件捕获
				//	$(this).addClass("over");	//添加css样式
				//},function(){
				//	$(this).removeClass("over");	//移除css样式
				//});
		oTable = $('#contable').dataTable({
			"iDisplayLength": 25,
			"aLengthMenu": [25, 50],
			"bProcessing": true,
			"bJQueryUI": true,
			"sPaginationType": "full_numbers",
			"oLanguage": {
				"sUrl": "lib/jquery_datatables_lastest/media/language/zh_CN.txt"
			}

		});
	});
</script>	
</head>

<body>
<%
	Set rs = Server.CreateObject("ADODB.Recordset")
	sql = "SELECT top 10000 *  FROM yb"
	rs.Open sql,conn,1,1
%>
<div class="navbar">
	<a href="customer.asp">客户信息管理</a>&gt;&gt;<a href="add_customer.asp">添加客户</a>&gt;&gt;
</div>

<table id="contable" class="display">
<thead>
  <tr>
      <th>客户名称</th>
      <th>客户地址</th>
      <th>装箱地点</th>
      <th>联系人</th>
      <th>联系电话</th>
      <th>注意事项</th>
      <th>业务员</th>
    </tr>
	</thead>
	<tbody>
	<% while not rs.eof %>
  	<tr>
      <td><a href="edit_customer.asp?customer_id=<%=rs("id")%>"><%=rs("id")%></a></td>
      <td><%=rs("tyr")%></td>
      <td><%=rs("cyr")%></td>
      <td><%=rs("rq")%></td>
      <td><%=rs("cmhc")%></td>
      <td><%=rs("dd")%></td>
      <td><%=rs("tdh")%></td>
    </tr>
	<% rs.movenext
	wend
	rs.close
	set rs=nothing
	conn.close
	Set conn=nothing
	%>
	</tbody>
	<tfoot>
  <tr>
      <th>客户名称</th>
      <th>客户地址</th>
      <th>装箱地点</th>
      <th>联系人</th>
      <th>联系电话</th>
      <th>注意事项</th>
      <th>业务员</th>
    </tr>
	</tfoot>
</table>
</body>
</html>
